Release 10.1A: OpenEdge Development:
Basic Database Tools

Generating a detailed table report

A detailed table report gives the following information for each table in the database:

Name
Description
Dump name
Flags
Field count
Index count
Labels
Storage area name
Trigger events
Trigger procedure filenames
A summary of each field, including:
Name
Order
Data type
Flags
Format
Initial value
Field label
Column label
A summary of each index, including:
Name
Flags
Count
Field name
Storage area
Details about each field, including:
Validation message.
Validation expression.
Description.
Help text.
Triggers.
Trigger procedure filenames.
Whether the field is overridable.
Whether to check the CRC.

To generate a detailed table report:

Choose Database Reports Detailed Table. The Data Dictionary alphabetically lists all the tables defined for your database.
Select a table or type ALL. The Report Options dialog box appears:



Specify the report destination. You can display the report on your terminal, print it, or save it to a file. If you want to save the report to a file, specify the filename and whether to append the report to an existing file.
Specify the page length.
Specify to order the fields by order number or alphabetically, then choose OK.

If you specified a file or printer, the Data Dictionary generates the report to the specified output destination. The Data Dictionary main window then reappears.

If you sent the report to the terminal, the Detailed Table Report dialog box appears. You can choose Change Field Order to reorder the fields, choose Print to print the report or write it to a file, or choose OK to close the Report Options dialog box.